	<?php
	include('dbcon.php');
	
	function checkValues($value)
	{
		 $value = trim($value);
		 
		if (get_magic_quotes_gpc()) {
			$value = stripslashes($value);
		}
		
		 $value = strtr($value,array_flip(get_html_translation_table(HTML_ENTITIES)));
		
		 $value = strip_tags($value);
		$value = mysql_real_escape_string($value);
		$value = htmlspecialchars ($value);
		return $value;
		
	}	
	
/*
 * 
 * name: clickable_link
 * @param
 * @return
 * 
 */
	function clickable_link($text = '')
	{
		$text = preg_replace('#(script|about|applet|activex|chrome):#is', "\\1:", $text);
		$ret = ' ' . $text;
		$ret = preg_replace("#(^|[\n ])([\w]+?://[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $ret);
		
		$ret = preg_replace("#(^|[\n ])((www|ftp)\.[\w\#$%&~/.\-;:=,?@\[\]+]*)#is", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $ret);
		$ret = preg_replace("#(^|[\n ])([a-z0-9&\-_.]+?)@([\w\-]+\.([\w\-\.]+\.)*[\w]+)#i", "\\1<a href=\"mailto:\\2@\\3\">\\2@\\3</a>", $ret);
		$ret = substr($ret, 1);
		return $ret;
	}

/*
 * 
 *	Searchs de string for latex code (between $$) and returns link with the corresponding image if found
 * 
 */

	function replaceLatex($text){
		
		$match = preg_match_all('(\$[^\$]*\$)',$text,$latexTextArray);
		//if there isnt latex in the text
		if ($match==0) return $text;
		
		
		$replacedText=$text;
		foreach ($latexTextArray[0] as &$latexText){
			
			
					
			//Remove the $ signs
			$result = substr($latexText,1);
			$result = substr($result,0,-1);
			
			//We replace the text for the latex img
			$replacedText = str_replace($latexText, "<img src=\"http://latex.codecogs.com/gif.latex?".$result."\" border=\"0\" title=\"\$".$result."\$\"/> ", $replacedText);
		
		}
		return $replacedText;
	}
	
	$next_records = 10;
	$show_more_button = 0;
	if(checkValues($_REQUEST['value']))
	{
		$userip = $_SERVER['REMOTE_ADDR'];
		
		mysql_query("INSERT INTO facebook_posts (post, userip, userid, f_name, l_name, materia, date_created) VALUES('".checkValues($_REQUEST['value'])."', '".$userip."', '".$_REQUEST['user_id']."', '".$_REQUEST['fname']."', '".$_REQUEST['lname']."', '".$_REQUEST['materia']."','".strtotime(date("Y-m-d H:i:s"))."')");
	
		$result = mysql_query("SELECT *,
		UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts WHERE materia = '".$_REQUEST['materia']."' order by p_id desc limit 1");
		
		showPosts($result, $_REQUEST['materia'], $show_more_button, $_REQUEST['user_id']);
	}
	elseif($_REQUEST['show_more_post']) // more posting paging
	{
		$next_records = $_REQUEST['show_more_post'] + 10;
		
		$result = mysql_query("SELECT *,
		UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts WHERE materia = '".$_REQUEST['materia']."' order by p_id desc limit ".$_REQUEST['show_more_post'].", 10");
		
		$check_res = mysql_query("SELECT * FROM facebook_posts WHERE materia = '".$_REQUEST['materia']."' order by p_id desc limit ".$next_records.", 10");
		
		$show_more_button = 0; // button in the end
		
		$check_result = mysql_num_rows(@$check_res);
		if($check_result > 0)
		{
			$show_more_button = 1;
		}
		
		showPosts($result, $_REQUEST['materia'], $show_more_button, $_REQUEST['user_id']);
	}
	else if ( isset( $_REQUEST['showPostsMateria'] ) )
	{
		loadPosts( $_REQUEST['materia'], $_REQUEST['user_id'] );
	}

	
	function loadPosts( $materia, $user_id )
	{
		$show_more_button = 1;
		$result = mysql_query("SELECT *,
		UNIX_TIMESTAMP() - date_created AS TimeSpent FROM facebook_posts WHERE materia = '".$materia."' order by p_id desc limit 0, 10");
		
		showPosts($result, $materia, $show_more_button, $user_id );
	}
	
	function showPosts( $result, $materia, $show_more_button, $user_id )
	{
		while ($row = mysql_fetch_array($result))
		{
			$comments = mysql_query("SELECT *,
			UNIX_TIMESTAMP() - date_created AS CommentTimeSpent FROM facebook_posts_comments WHERE post_id = ".$row['p_id']." AND materia = '".$materia."' order by c_id asc");		?>
		   <div class="friends_area" id="record-<?php  echo $row['p_id']?>">

		   <img src="https://graph.facebook.com/<?php echo $row['userid'] ?>/picture" style="float:left;" alt="" />

			   <label style="float:left" class="name">

			   <b><?php echo $row['f_name']." ".$row['l_name'];?></b>
				
			   <?php  echo replaceLatex(clickable_link($row['post']));?>
			   
			   <br clear="all" />

			   <span>
			   <?php  
			   
				// echo strtotime($row['date_created'],"Y-m-d H:i:s");
				
				$days = floor($row['TimeSpent'] / (60 * 60 * 24));
				$remainder = $row['TimeSpent'] % (60 * 60 * 24);
				$hours = floor($remainder / (60 * 60));
				$remainder = $remainder % (60 * 60);
				$minutes = floor($remainder / 60);
				$seconds = $remainder % 60;
				
				if($days > 0)
					echo date('F d Y', $row['date_created']);
				elseif($days == 0 && $hours == 0 && $minutes == 0)
					echo "Hace algunos segundos.";		
				elseif($days == 0 && $hours == 0 && $minutes < 55)
					echo "Hace ".$minutes.' minutos';
				elseif($days == 0 && $hours < 2)
					echo "Hace aproximadamente una hora";
				elseif($days == 0)
					echo "Hace ".$hours." horas";
				else
					echo "fijate que hay cagada en posts.php";
				
			   ?>
			   
			   </span>
			   <a href="javascript: void(0)" id="post_id<?php  echo $row['p_id']?>" class="showCommentBox">Comments</a>

			   </label>
			   <?php
				$userip = $_SERVER['REMOTE_ADDR'];
				if($row['userip'] == $userip){?>
				<a href="#" class="delete"> Remove</a>
			   <?php
				}?>
				<br clear="all" />
				<div id="CommentPosted<?php  echo $row['p_id']?>">
					<?php
					$comment_num_row = mysql_num_rows(@$comments);
					if($comment_num_row > 0)
					{
						while ($rows = mysql_fetch_array($comments))
						{
							$days2 = floor($rows['CommentTimeSpent'] / (60 * 60 * 24));
							$remainder = $rows['CommentTimeSpent'] % (60 * 60 * 24);
							$hours = floor($remainder / (60 * 60));
							$remainder = $remainder % (60 * 60);
							$minutes = floor($remainder / 60);
							$seconds = $remainder % 60;						
							?>
						<div class="commentPanel" id="record-<?php  echo $rows['c_id'];?>" align="left">
							<img src="https://graph.facebook.com/<?php echo $rows['userid'] ?>/picture" width="40" class="CommentImg" style="float:left;" alt="" />
							<label class="postedComments">
								<b>	<?php  echo $rows['f_name']." ".$rows['l_name']." ";?> </b>
								<?php  echo replaceLatex(clickable_link($rows['comments']));?>
							</label>
							<br clear="all" />
							<span style="margin-left:43px; color:#666666; font-size:11px">
							<?php
							
							if($days2 > 0)
								echo date('F d Y', $rows['date_created']);
							elseif($days2 == 0 && $hours == 0 && $minutes == 0)
								echo "Hace ".$seconds." segundos";		
							elseif($days2 == 0 && $hours == 0 && $minutes < 55)
								echo "Hace ".$minutes.' minutos';
							elseif($days2 == 0 && $hours < 2)
								echo "Hace aproximadamente una hora";
							elseif($days2 == 0)
								echo "Hace ".$hours." horas";
							else
								echo "fijate que hay cagada en posts.php";
							?>
							</span>
							<?php
							$userip = $_SERVER['REMOTE_ADDR'];
							if($rows['userip'] == $userip){?>
							&nbsp;&nbsp;<a href="#" id="CID-<?php  echo $rows['c_id'];?>" class="c_delete">Delete</a>
							<?php
							}?>
						</div>
						<?php
						}?>				
						<?php
					}?>
				</div>
				<div class="commentBox" align="right" id="commentBox-<?php  echo $row['p_id'];?>" <?php echo (($comment_num_row) ? '' :'style="display:none"')?>>
					<table>
						<tr>
							<td>
							<img src="https://graph.facebook.com/<?php echo $user_id ?>/picture" width="40" class="CommentImg" style="float:left;" alt="" />
							</td>
							
							<td>
							<label id="record-<?php  echo $row['p_id'];?>">
								<textarea class="commentMark" id="commentMark-<?php  echo $row['p_id'];?>" name="commentMark" cols="40"></textarea>
							</label>
							</td>
						</tr>
					</table>
					<br clear="all" />
					<a id="SubmitComment" class="small button comment"> Comment</a>
				</div>
		   </div>
		<?php
		}
		
		if($show_more_button == 1){?>
		<div id="bottomMoreButton">
		<a id="more_<?php echo @$next_records?>" class="more_records" href="javascript: void(0)">Older Posts</a>
		</div>
		<?php
		}
	}?>

	
	
